Monthly Archives: December 2013

Entity Data Modeling with Visual Studio

While there are a lot of tools out there for data modeling, there is one option that is free if you have Visual Studio.  It’s called the Entity Data Model Designer.  It works well if you need a quick-and-dirty way to create … Continue reading

Posted in SQLServerPedia Syndication, Visio, Visual Studio 2012 | 4 Comments

Power Query load settings

One point of confusion I see with Power Query is some people believe Power Query adheres to the Excel limit of a max of 1,048,576 rows that can be imported.  However, there is a way around this limit.  When using Power … Continue reading

Posted in Power BI, Power Query, SQLServerPedia Syndication | Leave a comment

I’m presenting at the PASS Business Analytics Conference

I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in San Jose, CA on May 7-9.  My presentation will be on Thursday, May 8th from 1:30-2:30pm.  Below is my presentation abstract along with … Continue reading

Posted in Data warehouse, PASS, Presentation, Session, SQLServerPedia Syndication | 3 Comments

Power Query Preview December Update

Microsoft keep turning out updates to Power Query.  For December, some of the new features (download): Connection to three more data sources: Sybase IQ, Exchange, and Dynamics CRM Online When using the Navigator pane in the Power Query search, it … Continue reading

Posted in Power BI, Power Query, SQLServerPedia Syndication | Leave a comment

Power BI for Office 365 FAQ

As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback, with many clients really loving it.  There are common questions that I hear, and I thought I would list them … Continue reading

Posted in Power BI, SQLServerPedia Syndication | 3 Comments

Certification Updates for SQL Server 2014

Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014: In reviewing the SQL Server 2014 product, the Microsoft Learning Experiences team determined that the new features focus on performance tuning and high … Continue reading

Posted in Certification, SQLServerPedia Syndication | Leave a comment

Power Query Preview November Update

As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft has been updating it frequently.  The latest update has many new features, among them: Connectivity to Windows Azure Table Storage … Continue reading

Posted in Power BI, Power Query, SQLServerPedia Syndication | Leave a comment

Power BI for Office 365 requirements

“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have a video at Power BI for Office 365 video).  Power BI is an Office 365 marketing offering (see pricing).  Each of … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, SQLServerPedia Syndication | 3 Comments