Archive | Microsoft RSS for this section

Wanted: BI Data Analyst/Data Mining Specialist

Looking for a BI opportunity?  Want to work in beautiful northern Michigan?  Do you have the desire to be part of a Great Place to Work?  Check out this opportunity to work for Hagerty Insurance.

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.

Advertisements

Does your business excel or just use Excel…?

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

Performance Tips for SSRS Reports

Kirk's Place

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

Always worth a shot to look at what Microsoft has to offer in the world of BI.  This collection of features looks ot be rather interesting.

office-365-logo-grey

Microsoft Power BI for Office 365 is a collection of features and services that enable you to visualize data, share discoveries, and collaborate in intuitive new ways.

Powermap Preview for Excel 2013 is released!

Wow, can Excel be a Power BI Tool?

Atidan

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.
http://www.microsoft.com/en-us/download/details.aspx?id=38395Image
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.
  • Image

View original post

Understanding Microsoft Self-Service BI Recording and Q&A

Devin Knight

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

Hip2Save

Not Your Grandma's Coupon Site

BI Corner

At the intersection of Business Intelligence & Analytics

Data and Analytics with Dustin Ryan

Dustin Ryan is a Data Platform Solutions Architect with Microsoft interested in Azure, SQL Server, and Power BI.

Data Visualization

Discover, Analyze, Explore, Pivot, Drilldown, Visualize your data... “How do I know what I think until I see what I say?” [E.M. Forster, G. Wallas, A. Gide]

Data Science 101

Learning To Be A Data Scientist

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

FiveThirtyEight

Nate Silver’s FiveThirtyEight uses statistical analysis — hard numbers — to tell compelling stories about politics, sports, science, economics and culture.

VizCandy

All Data and BI

citizenintelligence

The business blog

Dave Alper: Business Intelligence and Data Visualization

Lessons Learn from 20+ Years in the Trenches

Live, Nerd, Repeat

Making life better through the perfect application of humor and nerdery

digiphile

We're already living in the future. It's just not evenly distrbuted yet.

The Daily Post

The Art and Craft of Blogging

NFL.com Blogs

Official Blog of the National Football League

SNF All Access

Behind the scenes access into the world of Sunday Night Football