add reporting and analytics to mysql data in 10 minutes n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Add Reporting and Analytics to MySQL Data in 10 minutes PowerPoint Presentation
Download Presentation
Add Reporting and Analytics to MySQL Data in 10 minutes

Loading in 2 Seconds...

play fullscreen
1 / 12

Add Reporting and Analytics to MySQL Data in 10 minutes - PowerPoint PPT Presentation


  • 112 Views
  • Uploaded on

Add Reporting and Analytics to MySQL Data in 10 minutes. Journey from self-service to managed BI Rushabh Mehta, Mentor and Managing Director (India) Solid Quality Mentors www.solidq.com. Goals. Simplified data mash-up and analysis Extended Reporting Managed BI Goal #1 – BI in 10 minutes!.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

Add Reporting and Analytics to MySQL Data in 10 minutes


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
add reporting and analytics to mysql data in 10 minutes
Add Reporting and Analytics to MySQL Data in 10 minutes
  • Journey from self-service to managed BI
  • Rushabh Mehta, Mentor and Managing Director (India)
  • Solid Quality Mentors
  • www.solidq.com
goals
Goals
  • Simplified data mash-up and analysis
  • Extended Reporting
  • Managed BI
  • Goal #1 – BI in 10 minutes!
considerations
Considerations
  • Sales data processed into a Relational Dimensional Model
  • Data Cleansing already done as part of loading Model
  • Using MyISAM storage for rapid reporting
slide5
DEMO
  • Analyzing MySQL data
technologies used
Technologies Used
  • On Network
    • Data Sources
      • MySQL Database (Release 5.1.45) – Sales data
      • ATOM Data Feeds
  • On Client Machine [The Information Worker]
    • Data Sources
      • Text File
      • Excel
    • Drivers
      • MySQL Connector-ODBC 5.1.6 – DSN created to MySQL database
    • Data manipulation, model creation and analysis technologies
      • Excel 2010
      • PowerPivot Add-in for Excel 2010
slide7
DEMO
  • Extended Reporting
  • Reports against Analytical Model
  • Reports against MySQL
technologies used1
Technologies Used
  • On Network
    • Microsoft SharePoint Server 2010
        • Excel Services, PowerPivot Service, Analysis Services and Reporting Services
        • MySQL Connector-ODBC 5.1.6 and DSN
  • On Developer Machine [The Report Creator]
    • Business Intelligence Development Studio
    • MySQL Connector-ODBC 5.1.6 and DSN
  • On Client Machine [The Information Worker or Report Consumer]
    • Internet Explorer
    • .NET Framework
slide9
DEMO
  • Managed BI Solution
  • Managed Analytical Model
technologies used2
Technologies Used
  • On Network
    • MySQL Database
      • Sales Database
    • SQL Server 2008 R2
        • Analysis Services and Database Engine (additional data)
        • MySQL ADO.NET Provider
  • On Developer Machine [The Model Creator]
    • Business Intelligence Development Studio
    • MySQL ADO.NET Provider
  • On Client Machine [The Information Worker or Information Consumer]
    • Excel
    • Other client tools for OLAP
references
References
  • Technology References
    • www.powerpivot.com
    • www.microsoft.com/BI
    • www.sqlpass.org (Free 300+ Hours of deep technical recorded content)
  • Upcoming Free Educational Series
    • 24 Hours of PASS R2 (http://www.sqlpass.org/24hours/2010/)
  • Implementation and Training
    • www.solidq.com
  • Emails
    • Info @ solidq.com
    • Rmehta @ solidq.com