Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences.
Use Datazen with Analysis Services and MDX queries to create fast and effective mobile dashboard solutions. You can use drill-through actions to navigate to details and pass selections from one dashboard to another....More
Microsoft has positioned Power BI to be the industry-leading tool for simple self-service desktop data mashups but it has great heritage of serious business analytics. I’ve had numerous conversations lately with new consulting clients; both business leaders and technical professionals, who recognize the promise of Power BI and are anxious to put it to work solving real data problems. Are you ready to use Power BI to tackle your data challenges? On the 27th of August, I’ll lead an online virtual workshop “Building Business Intelligence Solutions...More
July 24th marked the General Availability release of major updates to Power BI Service and Power BI Desktop, Microsoft's cloud-based analytics and data visualization platform. Today's updates replace the previous "Power BI for Office 365" version and Power BI service that required either a subscription to Office 365 or Sharepoint Online for access.
Power BI Desktop...More
Creating a Forward-Looking KPI
Much of our organizational reporting today looks only at the past. It show us what happened in the past month, most recently completed quarter, or year-to-date. This information has value, but in many cases it would have more value if it would help us look to the future. Often, when decision makers look at past information, they use it to estimate a likely future state.
For example, a CFO looking at the following chart and assume that $2.676M represents ¾ of his total fiscal year sales:...More
Recently, I needed to optimize a nightly batch process for a SQL Server data warehouse that involved loading over 250,000 flat files. With a bit of experimentation and research, I was able to decrease the overall load time from 14 hours to under 15 minutes. To do so, I used:
something old - the T-SQL BULK INSERT command,
something new - Memory-Optimized tables in SQL Server 2014, and...More
As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
Microsoft Datazen is a robust, enterprise-scale server-hosted mobile dashboard platform that works on every mobile platform – the iPad and iPhone, Windows desktop, tablet and phone, Android devices and HTML5 with full fidelity. To use Datazen, you don’t need SharePoint, a cloud subscription, Office or any other software....More
In this article, second in the series, we setup the Datazen server in preparation for designing basic dashboards in Part 3. Later on, we’ll explore advanced designs and dashboard interactions using parameters and drill-through navigation. If you haven’t already, read the first article to understand the server components and tools you’ll need to get started....More
Effective Data Visualization – The Eradication of Ruler Reports
I once had an efficiency consultant tell me that he went into an office looking for a ruler left out on someone’s desk. This was a sure sign that person received one or more reports that were so large and so complex, it was necessary to lay a ruler across the report in order to read it properly. These “ruler reports” were the first candidates to be redesigned and replaced....More
Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More