You are browsing the archive for Business Intelligence.

Apr 10 – Dan Evans – SQL Server 2014 Launch – Accelerate Your Insights

April 5, 2014 in Meetings

When: Thursday, Apr 10th
Pizza at 5:00 PM
Meeting at 6:00 PM

Where: Microsoft Office
6465 N. Quail Hollow Rd., Suite 200
Memphis, TN
38120-1417 (View Map)


Update: The “deck” from Thursday’s meeting can be downloaded from here: SQL Server 2014 Overview with Data Insights – Memphis PASS April 2014k


On April 1st, Microsoft released SQL Server 2014 and it was no joke. Join us Thursday, April 10th, as Dan Evans takes us through our first look at SQL Server 2014.

As usual, pizza will be served around 5:30 PM and the meeting will start at 6 PM.

For those arriving after 5:30, the door code will be posted here as soon as soon as it becomes available.

If you plan to attend, please RSVP so we know how much pizza to get, and so that we know who to contact if there are any changes that need to be communicated. You can RVSP at: http://www.meetup.com/memphis-technology-user-groups/events/175483982/

Abstract:
Big data. Small data. All data. You have access to an ever-expanding volume of data inside the walls of your business and out across the web. The potential in data is endless – from predicting election results to preventing the spread of epidemics. But how can you use it to your advantage to help move your business forward?

Data is growing exponentially and it’s now possible to mine and unlock insights from data in new and unexpected ways. Empower your business to take advantage of this data by harnessing the rich capabilities of Microsoft SQL Server and the familiarity of Microsoft Office to help organize, analyze, and make sense of your data – no matter the size.

Want to learn more? Join us and see how to drive real-time business, from apps to insights, through a deeper look into the comprehensive in-memory technologies in Microsoft SQL Server 2014 and Power BI for Office 365. Attending this event will allow you to get a running start on understanding the extensive innovations we’re delivering around data that will empower your business with the tools you need to quickly uncover business insights and make smarter business decisions.

Bio:
Dan Evans is a Senior Technology Solution Professional on the BI and Analytics platform at Microsoft. He brings over 20 years’ experience developing and delivering innovative analytic solutions on the Microsoft platform. Dan has presented at numerous regional and national conference including TechEd, PASS, DAMA, and TDWI, regarding best practices and architecture utilizing both on premise, cloud and hybrid solutions. He now supports many regional user groups including PASS, DAMA, TDWI, and the newly formed Modern Excel User Group (MEUG).


Number of View :1898

2014 – Jan 9th – Dan Evans – Deep Dive into BI on the Fly

January 6, 2014 in Meetings

When: Thursday, Jan 9th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Happy New Year everyone.

Join us on Thursday, Jan 9th, for the chapters first meeting of the new year. We’ll begin the meeting with some important news regarding Memphis PASS Chapter and then a short discussion about the future of the group. After that Dan Evans will take us for a deeper dive into BI on the Fly.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

BI on the Fly – With Excel as the predominant data analysis tool, all users can perform deep, rich data location, integration, delivery, and visualizations using everyday tools. Excel has the ability to quickly locate data with Data Explorer and structure information in PowerPivot to create strong correlations between items and create a foundation for further analysis. Come hear more about combining PowerPivot for self-service BI reporting with GeoFlow for 3D visualizations to provide a comprehensive and compelling view of information to engage others in true collaborative BI.

Bio:

Dan Evans is a senior Technical Solution Professional (TSP) with Microsoft focusing on Business Intelligence and Data Analytics.  Dan builds trusted relationships with accounts in the Heartland District to advise customers on the benefits of using the Microsoft Data platform by growing awareness and supporting adoption.   He holds several technical and professional certifications (MCP, MVP, CBIP) in the industry and has presented at national conferences like TechEd, PASS and TDWI.

 

Eventbrite - Memphis PASS - Dan Evans - Deep Dive into BI on the Fly


Number of View :7283

Nov 14th – Jorge Segarra – What is a BI DBA?

November 10, 2013 in Meetings

When: Thursday, Nov 14th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Nov 14th, as Jorge Segarra talks to us about what is a BI DBA.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

What is a BI DBA?

Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment then come join us on Thursday.

Bio

Jorge Segarra is a DBA consultant for Pragmatic Works and a SQL Server MVP. In addition to being a member of the Jacksonville/Tampa SQL Server User Groups, he is a former Regional Mentor for PASS. Jorge has co-authored the Apress book “SQL 2008 Pro Policy-Based Management” as well as the “SQL Server 2012 Bible” and was a Red Gate Software Exceptional DBA of the Year 2010 finalist. He also founded SQL University, a community project aimed at helping people learn SQL Server from the ground up, which you can find at http://sqluniversity.org

 

Eventbrite - Memphis PASS - Jorge Segarra – What is a BI DBA? - Nov 14th


Number of View :8344

Aug 8th – Steve Anderson – Using Microsoft SQL Server Analysis Services & Reporting Services for Data Analytics

August 6, 2013 in Meetings

When: Thursday, Aug 8th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Aug 8th, as Steve Anderson walks us through an example of how to use Analysis Services & Reporting Services for Data Analytics.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

Steve Anderson will walk us through an example of how to use Analysis Services & Reporting Services for Data Analytics.

Bio:

Steve Anderson is a database and analytics professional who received a Master of Engineering Management degree from Christian Brothers University and a Bachelor of Science in Computer Engineering from The University of Memphis. He is currently a Database Marketing Manager for a financial services institution in San Francisco CA. Mr. Anderson specializes in: Database Marketing, Data Analysis, Data Warehousing, Report Development & Business Intelligence. His expertise expands across several industries – sports, entertainment, financial services, gaming, and retail.

Eventbrite - Memphis PASS - Steve Anderson - SSAS & SSIS for Data Analytics


Number of View :78911

Mar 14 – Dan Evans – SQL Server 2012 BI Updates

March 12, 2013 in Meetings

When: Thursday, Mar 14th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Mar 14th, as Dan Evans talks to us about what’s new with SQL Server 2012 BI.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

Some new significant announcements have come out in the recent weeks related to SQL Server and the BI stack.

  1. SQL Server Data Tools for VS2012
  2. Data Explorer Preview (with Power View and PowerPivot)
  3. Hortonworks Data Platform for Windows
  4. Parallel Data Warehouse for SQL Server 2012

Come see and hear more regarding new developments in this area. This discussion will be mostly interactive and totally off script – so come help learn with the instructor about how to take your SQL Server environment to the next level.

Bio:

Technology consultant with over 20 years experience in applying innovative solutions to business needs. Key focus areas are Business Intelligence, Enterprise Performance Management and Data Strategy. Work heavily in promoting technology in the Southeast through involvement with regional user groups (.NET, PASS) and industry-recognized organizations (TDWI, DAMA).

Specialties include Business technology solutions, data warehousing, business intelligence, project management, technical strategic planning and new business development. Dan has spoken at TDWI, TechNet and PASS on industry best practices in these areas.

Dan is also the president of the Memphis PASS Chatper (Mem-PASS).

 

Eventbrite - Memphis PASS - Dan Evans - SQL Server 2012 BI Updates for 2013


Number of View :18352

Apr 12th Meeting – Dan Evans – What’s New With BI in SQL Server 2012?

March 31, 2012 in Meetings

When: Thursday, Apr 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, April 12th, as Dan Evans talks to us about what SQL 2012 has new for BI.

As usual, refreshments will be served around 5:30 PM and the meeting will start at 6 PM.

Abstract:

With the recent launch announcement SQL Server 2012, Microsoft has focused on providing enterprise-ready Business Intelligence platform to support all of an organizations data needs. A new edition of SQL Server – the BI Edition – focuses entirely upon delivering these solutions with the optimal assembly of assets necessary for deployments.

In his presentation, Dan will talk to us about:

  • Understanding more about the components included in SQL Server 2012 BI Edition and comparisons between editions
  • Identifying highlights of major changes since 2008 R2
  • Seeing BI in action with Management Studio, Visual Studio, Reporting Services, Analysis Services and PowerPivot/PowerView
  • Capturing necessary resources to get started with SQL Server 2012

Bio:

Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.

 

Eventbrite - Memphis PASS Chapter - Dan Evans - What's New With BI in SQL Server 2012?


Number of View :3069

Mar 15th Meeting – Charles Watkins – SQL Server 2012 PowerView

February 23, 2012 in Meetings

When: Thursday, Mar 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Abstract:

Join us on Thursday, Mar 15th, and give a warm welcome to Charles Watkins from New Horizons.

SQL Server 2012 (formally code named Denali) has introduced the new Business Intelligence Semantic Model (BISM) supported by PowerView.

Power View is an interactive data exploration, visualization, and presentation experience that replaces Report Builder 1.0.  It allows for adhoc report creation based on Excel 2010 PowerPivot or the new Sql Server 2012 Analysis Services  (SSAS) tabular models.  PowerView is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations. It is an extension of Sql Sever 2012 Reporting Services.

We will be introduced to the setup, and potential use of PowerView.

Bio:

Charles B. Watkins, Sr. has experience in working with business entities public, private and nonprofit.  He has be the primary instructor for Sql Server at New Horizons for the past 13 years and has been an employee of New Horizons Computer Learning Center of Memphis for a total of 16 years.  He is certified in  Sql Server 2000, 2005, 2008 – Windows 2000, 2003, 2008 – Sharepoint 2010 – Windows Vitalization – and Lotus Notes (MCP, MCT, MCSA, MCSE, MCTS, MCITP, CLI, CLP).

He loves anything dealing with computers and the new technology that is surrounding Windows, Sql and Sharepoint.

Register for Memphis PASS Chapter - Charles Watkins - SQL Server 2012 PowerView in Memphis, TN  on Eventbrite


Number of View :7712

Jan 12th Meeting – Dan Evans – Knight’s 24-hour Business Intelligence Trainer – Section VI – SharePoint

January 2, 2012 in Meetings

When: Thursday, Jan 12th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Jan 12th, as Dan Evans walks us through Section VI of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer and shows us how Microsoft SharePoint fits in the BI environment.

Abstract:
This month we will be wrapping up the review of the 24-Hours of BI with the final section on SharePoint BI. Come learn the main concepts of SharePoint as they relate to your BI efforts. See how to deploy SSRS reports and create Dashboards in PerformancePoint. You can view how Excel services can help your BI efforts and maybe even see some neat things with PowerPivot. We’ll also highlight some basic security and administration features within SharePoint so you can maximize your investment in Microsoft technologies.

Bio:
Dan Evans is the Director and Market Lead for the Americas Business Intelligence Service Line at Avanade, Inc. He benefits from 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel promotes technology for business use through various channels by sponsoring user groups like The Data Warehousing Institute (TDWI) Mid-South Chapter, the Mid-South Data Management Association (DAMA) chapter and is founder and acting president of the Memphis Professional Association of SQL Server (PASS) chapter. Dan holds several MCPs in SQL Server and SharePoint and is Certified Business Intelligence Certification (CBIP) with Mastery in Leadership and Management, Business Analytics, Data Analysis and Design and Data Integration. Daniel is a nationally recognized speaker at TDWI, TechEd and PASS on topics related to SQL Server and SharePoint.

Register for Knight's 24-hour Business Intelligence Trainer - Section VI - SharePoint in Memphis, TN  on Eventbrite


Number of View :2565

Dec 15th Meeting – Douglas Johnston – SQL Server Denali (SQL Server 2012)

November 27, 2011 in Meetings

When: Thursday, Dec 15th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Abstract:
This month, Douglas Johnston introduces the new version of SQL Server, codename Denali.  From T-SQL additions to the new Integration Services designer, from Master Data Services to the new Visual Studio project types, he will walk through a real-world example of each.  As Douglas is also currently implementing all of these for a client, he will also demonstrate the pitfalls and bugs of the pre-release software.  If you are considering upgrading to SQL Server 2012, this session will give you great information on what the benefits and the risks are.

Bio:
Douglas Johnston is a Group Manager in the Business Intelligence & Collaboration Service Line of Avanade. With 10 years of experience with SQL Server and business intelligence tools, in industries as diverse as healthcare, financial services, defense and energy utilities, he has become one of the leading contributors to the Avanade BI community. He advises on, and develops projects with, aspects of database development, performance tuning, architecture, warehouse design and management, high availability, ETL and reporting systems. He is also a founding member of the peer-nominated Avanade Expert Network and holds several Microsoft certifications.

Before becoming a database ninja, Douglas developed with VB6, Perl, Oracle, Business Objects and J2EE, as well as some other really terrible technologies. He has particularly desiccated sense of humor to go with the British accent, owns a kilt, and likes monkeys.

Register for Memphis PASS Chapter Meeting - Douglas Johnston – SQL Server Denali in Memphis, TN  on Eventbrite


Number of View :7446

Nov 10th Meeting – Dan Evans – 24-hour Business Intelligence Trainer – Section 3 – SSAS

November 6, 2011 in Meetings

When: Thursday, Nov 10th
Pizza at 5:30 PM
Meeting at 6:00 PM

Where: New Horizons
4775 American Way
Memphis, TN, 38118

Join us on Thursday, Nov 10, as Dan Evans walks us through Section III of the best-selling book Knight’s Microsoft Business Intelligence 24-hour Trainer as we look at SQL Server Analysis Services (SSAS) in the BI environment.

Abstract:
For this month’s meetinng, we’ll be going over Section III of the Knight’s Microsoft Business Intelligence 24-Hour Trainer about SQL Server Analysis Services (SSAS).   We’ll show the major components of SSAS including Data Sources, Dimensions and basic MDX expressions.  You’ll see how these points are aplied using the SSAS project and the Cube Wizard.  Come learn what SSAS is an what it can do for your Business Intelligence (BI) projects!

Bio:
Dan Evans benefits from almost 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


Number of View :2142

Switch to our mobile site