05 septiembre 2013

TechNet’s subscription retirement and the Microsoft Certified Trainers (MTC) program impact

 

If you are an MCT, you should already know about the Microsoft TechNet’s retirement announcement plan. Based on this, there has been a lot of discussion inside the MCT community and social networks during the last few weeks. To our benefit, some MCTs had taken the lead and the initiative contacting Microsoft directly to tell them more about the basic tools we as MCTs need in order to keep doing a great job for our students.

One of this MCTs is Kostantin Ceran. For this reason following I‘m sharing Kosta’s last update (with his permission) regarding his communications with the Microsoft Learning team for all MCTs and specially those in the Puerto Rico region.

Alan

---

I am the Regional Lead for Microsoft Certified Trainers in Turkey. Following Microsoft’s announcement about TechNet’s retirement, I have tried to create awareness within Microsoft that the adopted way of action will hurt legitimate customers and will cause long-term financial loss for both parties. I decided to send an e-mail to Steve Ballmer, which was kindly welcomed. This allowed me to discuss the matter with the managers of Microsoft Learning.

Furthermore, I wrote a report about the long-term effects of TNS retirement on the MCT community. I prepared an MCT value proposition and presented it to the management of Microsoft Learning. Their initial reaction was positive and I hope that my report will be able to spark some discussion during the MCT Summit in September.

Today, I have received information that Microsoft have decided to partially remedy the complaints of the MCT community. I am expecting further developments during the next couple of weeks, but as of today, 3 points have been made clear by Microsoft:

  1. TechNet subscribers that have activated their accounts before the 1st of September will receive a “free, one-time, 90 day subscription extension”. This will adjust the date of the current MCT TechNet subscription deadline to 29 June 2014, earliest. The exact date of expiration can be checked from the “My Account” page of the TechNet Subscriptions benefits portal. You can continue to access downloads and licenses until your updated expiration date is over. For details go to http://technet.microsoft.com/subscriptions/default.aspx

  1. TechNet Evaluation Center will start providing access to prior versions of the available trial software. Windows 7, Windows Server 2008 R2, and Office 2010 are made available as of today. Microsoft stated that they will add additional products over time. For details go to http://technet.microsoft.com/en-US/evalcenter/dn407368


  1. For MCTs only, Microsoft plans to replace their current TechNet NFR Subscription with a new solution (yet to be determined) that will provide them access to non-time bombed software for the duration of the 2014 MCT program membership year. As expected, the software contained in the said solution will be used for instructional purposes only. More details will be available in the coming weeks.

Konstantin Ceran

04 septiembre 2013

Exam 70-461 (T-SQL SQL Server 2012) preparation Jump Start

For all people interested in taking exam 70-461 (requirement for any SQL Server 2012 certification) or in learning more about the new T-SQL enhancements in SQL Server 2012, the SQL Server Team will be presenting a full day online training and best of all, for FREE!. More information and registration here: http://blogs.technet.com/b/dataplatforminsider/archive/2013/09/04/querying-microsoft-sql-server-2012-databases-jump-start-september-13th.aspx. (Thanks to @SQLTitan for the info).

Alan

 

Querying Microsoft SQL Server 2012 Databases Jump Start–September 13th

If you’re already familiar with database fundamentals and you’ve worked with SQL Server, the Querying Microsoft SQL Server 2012 Databases Jump Start course will help you take your skills to the next level. You’ll learn about data manipulation and how to alter tables, and you’ll see it all in action in the demos presented by the experts: Brian Alderman, CEO and Founder of MicroTechPoint, and Tobias Ternstrom, Microsoft Program Manager in the SQL Server division. If you’re working on a Microsoft certification, this course will help you prepare for Exam 70-461.

Register now for this course to get a detailed look at:

  • Introduction to SQL Server 2012
  • Advanced SELECT statements
  • SQL Server data types
  • Grouping, aggregating and modifying data
  • Table expressions and SET operators
  • Programming with T-SQL
  • Retrieving SQL Server metadata

This course takes place:

Date: September 13, 2013
Time: 9:00am – 5:00pm
Where: Live, online virtual classroom
Cost: Free!

28 agosto 2013

Introducción a Self Service Business Intelligence con Excel – Parte 2

Como les comenté, hace algunos días tuve la oportunidad de realizar una presentación para el Instituto de Ingenieros en Computadoras (IICOM) de Puerto Rico con respecto a Self Service BI. En este post les presento la segunda parte de dicha presentación y si no lo han hecho ya, los invito a revisar la primera la primera parte de esta serie en éste enlace.

En esta segunda parte nos adentramos al uso de Excel como herramienta de Business Intelligence específicamente haciendo demostraciones de los componentes de Power BI: Power Query, Power View y Power Map. Debido a que el objetivo de la sesión era dar una vista de 360 grados del potencial de Excel como herramienta preferí dejar el tema de Power Pivot para una próxima presentación y en su lugar darle mayor espacio a Power Query.

Esta segunda grabación tiene una duración de casi 1hr 40Mins. Si quieren visitar directamente alguna de las demostraciones, a continuación una guía de los mismos:

  • Power Query: Analizando el uso de los archivos de nuestra PC (11:45)
  • Power Query: Buscando y explorando data – Wikipedia (23:45)
    Lista de Radios en Puerto Rico
    Jugadores de la NBA con mayor cantidad de premios MVP
  • Power Query: Extrayendo datos desde páginas web (43:00)
    ClasificadosOnline.com
  • Power Query: Importando  y analizando datos desde GapMinder (1:00:22)
    Índice de Masa Corporal  (BMI), PBI per Cápita (GDP) y Población
  • Power Map Demo (1:31:35)

En cada uno de los demos usando Power Query realizo alguna visualización rápida con pivot tables de Excel o con Power View.

Sin más detalles los dejo con la grabación. Espero lo disfruten.

Alan

26 agosto 2013

Introducción a Self Service Business Intelligence con Excel – Parte 1

Hace unos días tuve la oportunidad de brindar un seminario para el Instituto de Ingenieros en Computadora (IICOM) de Puerto Rico. El enfoque del seminario fue llamar al interés de los participantes a que puedan conocer e interesarse de alguna de las nuevas herramientas para el manejo y análisis de datos a las que podamos tener acceso hoy en día.

Por este motivo, preparé este seminario de casi 3 horas de duración en donde la primera parte del mismo y presentada en este post, busca llamar la atención con respecto a las últimas tendencias de las Tecnologías de la Información (TI), así como algunos aspectos básicos de los temas de interés como lo son Big Data y Self-Service Business Intelligence (BI).

Update 1: Incluyo la presentación desde SlideShare para referencia:

En la próxima entrega estaré publicando la segunda parte del seminario, en donde presento demostraciones prácticas de cómo trabajar con Excel como herramienta de Self Service BI, específicamente haciendo uso de Power BI el cual incluye las herramientas Power Query, Power Pivot, Power View y Power Map.

Pónganse cómodos y espero disfruten el video.

Alan

19 agosto 2013

Presentación en el CIAPR

Para no perder la costumbre, este miércoles 21 de agosto estaré presentando el tema “Enabling Self Service Business Intelligence using Excel” en la sede central del Instituto del Ingenieros en Computadoras del Colegio de Ingenieros y Agrimensores de Puerto Rico. El seminario tendrá una duración de dos horas y media, tiempo suficiente para ver un poquito de las novedades de Excel 2013 y Power BI. El ingreso es libre.

PromoSeminarioBIExcel2013

A los que estén cerca, espero verlos por ahí.

Alan