add reporting and analytics to mysql data in 10 minutes
Download
Skip this Video
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


  • 106 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

PowerPoint Slideshow about ' Add Reporting and Analytics to MySQL Data in 10 minutes' - vesna


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
ad