Power your Project Management with Power Query

Power your Project Management with Power Query

When running a project, every project manager (PM) maintains a task list, in some form or fashion, to be able to track their progress. Sometimes the PM manages and maintains one task list; however, when projects scale, more complex tracking techniques are needed. A common problem for PMs is the need to consolidate data from several teams, in the form of task lists, status reports or weekly...

Read More

Emerging BI applications easily enable data discovery and visualization on any device

If you’ve been happily working in Microsoft SQL and Excel for your business intelligence and reporting solutions, you may not have had much motivation to look at the offerings outside of the Microsoft stack. But if you find that not everyone wants to work in Excel, or that Reporting Services and Power BI (including Power View) disappoints when it comes to rich visualizations or ease of use...

Read More

Spreadsheet Evolved: Solving Non-Smooth Business Optimization Problems Using Microsoft Excel 2010+

Tallying monthly sales figures, categorizing expenses, tracking office fantasy football league stats – traditional wisdom paints Microsoft Excel as a useful, albeit unsophisticated, tool for performing ad hoc analysis around the office.  But while Excel is certainly easy to use, its simplicity belies a powerful ability to provide business users with advanced analytics in a fast and flexible...

Read More

Data analysis with Predixion Analytics

I’m taking a class to learn about this new field of data science, and one of the most interesting things I’ve been exposed to so far is a program called Predixion Insight. The documentation to learn how to use the tool is pretty useful and it quickly demonstrates how you can use the tool to predict factors that are necessary for determining hospital re-admittance probabilities.…

Read More

Examining Geo Data with Excel 2013 Power View

I was first exposed to data visualization on maps while working on an anti-piracy project for a software company.  Our efforts included layering multiple levels of information both automated and manually collected onto Bing maps.  Seeing the collaboration of data points on the same map gave insight to the intensity and impact of digital piracy on both region/sub-region levels where KPIs could...

Read More

A Quick Tip on DQS Data Mapping Validation

After importing our mapping data into DQS, the business I was working with wanted to verify that all the values were mapped/matched correctly. We had a lot of data, so scrolling thru the UI to visually test was not realistic, and we’d also need an export of the mappings. Since there isn’t an export option thru the UI, I looked at the SQL tables.…

Read More

Self-Service BI. Really?

I’m pretty skeptical of BI marketing pitches, (working as I do as a consultant in the trenches somewhere between business leaders, end users, and IT developers). But after hands-on experience with Microsoft’s latest BI tools – Power Pivot and Power View for SharePoint—I feel persuaded that “self-service BI” are not just buzz words. …

Read More
Phone: 312-602-4000
Email: marketing@westmonroepartners.com
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons