Hagerty Insurance, headquartered in Traverse City, MI, has an opening for a BI Data Analyst/Data Mining Specialist. To find out more about this position and check out more about Hagerty’s great career opportunites visit here!
Follow @Hagerty on Twitter to experience what we are all about! Trust me, it is an AWESOME place to work.
All pitfalls mentioned here are pains when working with Excel, but sharing data is one of the biggest pitfalls when using Excel. Determining what version of the truth is accurate can become very frusterating and also very dangerous.
From the Construction Industry Benchmarking Survey we launched last year, where we have asked business’s about how they are using systems and technology in their core business processes, we have found that ALL businesses, no matter their size or discipline who participated in the survey, appear to be extensively using excel within many of their key processes. From developing reports to undertaking forecasting and business planning to the development of tender estimates, it appears Excel has got a tight grip on the Industry. Does this mean that businesses are excelling at what they are doing…. or are they just using Excel? This post will look at why Excel has such a tight grip, what the pitfalls are of being overly reliant on it and then to look at how you might be able to move away from a Excel driven business to make your business more robust, transparent , controllable, effective…
View original post 1,519 more words
Here are a few tips I’ve discovered whilst building SSRS reports to host in SharePoint. Some of these are report based tips and a few apply to SharePoint. I willadd to and update these as I discover more.
1. [Report based] Avoid using the Total Pages built in field as if you use this the rendering engine has to complete a full pre-render of the entire report primary dataset before it starts the final render. This can add a great deal of processing overhead and the report will take much long to finally display;
2. [Report based] Ensure results are paged. This should occur by default but if you choose to turn it off for your report there is a risk that you will encounter problems as the HTML rendering format that is used to initially render a report opens the report in your browser. If the report is not…
View original post 94 more words
Wow, can Excel be a Power BI Tool?
Power Map is a 3D data visualization tool for Excel that provides an immersive experience for making discoveries in data that might never be seen in traditional 2D tables and charts. Power Map lets you plot geographic and temporal data visually, analyze that data in 3D, and create cinematic tours to share with others.
With Power Map you can:
- Map Data: Plot more than a million rows of data* in 3D visually on Bing maps and visualize the data with 3D columns, bubble/pie charts, heat maps, and regions.
- Discover Insights: Discover new insights by seeing your data in geographic space and seeing time-stamped data change over time.
- Share Stories: Capture screenshot “scenes” and build cinematic, guided interactive or video “tours” that can be shared broadly, engaging audiences like never before.
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If you weren’t you can now download the recording here.
Because I covered new material all the way to the end of the webinar i thought I’d also answer some of the top questions I didn’t have time to answer here.
Q: Can an Excel Power Pivot 2013 model be read by Excel 2010 or Excel 2007? What about Excel versions and their compatibility with SharePoint Versions? I ask because we are upgrading our SharePoint environment to 2013 but most of our users have Excel 2010 (a few have 2007).
You can open an Excel 2013 workbook that has a Power Pivot model in older versions but you cannot modify them. You can however deploy Excel 2010 and Excel 2013 workbooks to you SharePoint 2013 environment and it they interact…
View original post 281 more words